﻿CREATE TABLE [dbo].[Parliamentarians] (
    [CPALId]          INT            NOT NULL,
    [Title]           NVARCHAR (20)  NULL,
    [FirstName]       NVARCHAR (50)  NULL,
    [Surname]         NVARCHAR (50)  NULL,
    [Honorific]       NVARCHAR (50)  NULL,
    [Electorate]      NVARCHAR (50)  NULL,
    [State]           NVARCHAR (4)   NULL,
    [Chamber]         NVARCHAR (25)  NULL,
    [Telephone]       NVARCHAR (50)  NULL,
    [Fax]             NVARCHAR (50)  NULL,
    [EmailAddress]    NVARCHAR (100) NULL,
    [FacebookAddress] NVARCHAR (100) NULL,
    [TwitterAddress]  NVARCHAR (100) NULL,
    [PersonalWebsite] NVARCHAR (100) NULL,
    [PartyWebsite]    NVARCHAR (100) NULL,
    [MPID]            NVARCHAR (10)  NOT NULL,
    [FormerMember]    BIT            NOT NULL,
    [Gender]          NVARCHAR (MAX) NOT NULL,
    [PreferredName]   NVARCHAR (MAX) NULL,
    [PartyRecId]      INT            NOT NULL,
    [OtherNames]      NVARCHAR (MAX) NULL
);





